All Questions
24 questions
5votes
5answers
6kviews
How can I protect an SQL connection string in a client-side application?
I am developing a .NET Windows application and I need to make requests to a SQL Server instance. How do I secure the authentication data in my code in case someone decompiles my application? I know ...
- 85
0votes
1answer
86views
MVC database connection .NET
Introduction I intend to create a .NET WinForms application (this will be a toy application) which connects to a SQL Server database backend. I have designed and implemented an object-oriented model ...
- 275
0votes
0answers
190views
Tradeoffs between Testability and Performance when filtering using SQL vs LINQ
My team has recently decided to adopt the CQRS pattern similar to the one used in the famous Microsoft EShopsOnContainers repository. In this solution, the queries are made in Query classes using ...
- 103
0votes
3answers
1kviews
How can I interpret a SQL Check Constraint inside my C# .NET class libary?
I was given a more or less complex task. The goal is to interpret a SQL Check Constraint inside my C# .NET libary. In our case we have a simple UI that displays what is inside the database. We do not ...
-2votes
2answers
2kviews
What does it mean to "wrap" a stored procedure?
My manager has asked me to "just wrap the stored procedure". The requirements are to create a microservice that will do the following: Accept parameters from the user. Pass those parameters to the ...
- 495
-1votes
1answer
98views
.NET Sort concurrent requests into a queue
I asked this at Stack Overflow but seeing as it wasn't so much a programming issue as a theory issue it wasn't well received. I have a program that issues a unique ascending code every time one is ...
7votes
5answers
2kviews
Data layer without ORM - how to work with it in efficient way?
I work on a big .NET project. It started more than 10 years ago, there is no ORM (NHibernate or EF I mean) and there is no chance to migrate to some widely used ORM (and for complex SQL queries ORM ...
0votes
3answers
9kviews
Best way to query data from database and then modify it
I'm working on a software using VB.Net which retrieves string packets through a TCP socket. The problem is it receives hundreds of packets per second. For each incoming packet the software should ...
- 161
2votes
2answers
2kviews
SQL query or C# .net code for csv files import?
My aim here is to find out the best possible and feasible solution for my dilemma. I want to import some csv file (may contain around 50~60K records) into database after some manipulation into the ...
- 121
1vote
2answers
102views
Working with local connections instead of global
In recent weeks I became very concerned that the way I've been working with database connections for the past years, is simply wrong. I exclusively create a new connection for each database operation ...
- 113
2votes
1answer
1kviews
SQL - Designing a Threshold value table
I need to design an SQL table to be used for "threshold" or special values, which in general would have the following properties: - key - value - comparer (less than and greater than as a start, ...
5votes
3answers
4kviews
ASP.NET MVC should I reference the DAL from the UI?
I am developing an ASP.NET MVC application, and I have three projects: UI (with the system.web.mvc reference, BL and DAL references) BL (business facade and business objects) DAL (contains my ...
0votes
2answers
276views
Working with data and meta data that are separated on different servers
While developing a product, I've come across a situation where my group wants to store meta data for data entry forms (questions, layout, etc) in a different database then the database where the ...
- 357
0votes
1answer
1kviews
What is the proper and easy way to move a LocalDB to Azure using code first ?
The only way I could figure how to do it was create the schema on the localDB with code first and then manually change the database string to Azure and then run the code on Azure.. But that only ...
- 1,123
0votes
2answers
13kviews
Best place to write SQL queries
I've been working on this project for my company. Currently I am embedding my SQL statements inside the program itself as and when they are needed. I do have two seperate classes - QueryBuilder Class ...
